SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=2 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=101 AND MATCH (t.strSearch) AGAINST ('+auto +mobile +logos' IN BOOLEAN MODE)) AND iCityID IN (68823,69350,66982,67062,67143,70100,67285,68857,69611,67358,66981,70302,67040,67147,69173,67145,68422,67838,67041,70091,70301,67397,68765,67169,67229,70095,69460,67776,67940,70300,70050,70297,70296,68142,70298,70303,67553,70195,70152,68359,70399,70299,70400,70398,68748,67022,67936,67766,69285,69604,67673,69606,68080,68079,67171,68427,70379,69251,67739,70295,68357,69228,67784,67765,67141,68292,67778,69164,69558,68243,68742) ORDER BY FIELD(iCityID, 68823,69350,66982,67062,67143,70100,67285,68857,69611,67358,66981,70302,67040,67147,69173,67145,68422,67838,67041,70091,70301,67397,68765,67169,67229,70095,69460,67776,67940,70300,70050,70297,70296,68142,70298,70303,67553,70195,70152,68359,70399,70299,70400,70398,68748,67022,67936,67766,69285,69604,67673,69606,68080,68079,67171,68427,70379,69251,67739,70295,68357,69228,67784,67765,67141,68292,67778,69164,69558,68243,68742) ASC, p.tmPosted DESC LIMIT 24
auto mobile logos, Automobile Classifieds, Used Cars, Used Motorcycles, Commercial Vehicles, Trucks in Kanchipuram
